CREATE TABLE [dbo].[MapHotelRoomAvailables]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[HotelId] [int] NOT NULL,
[RoomCategoryId] [int] NOT NULL,
[AvailableCount] [int] NULL,
[FromDate] [datetime] NULL,
[ToDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MapHotelRoomAvailables] ADD CONSTRAINT [PK__MapHotel__3214EC072B3F6F97] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
